CREATE PROCEDURE GetHolidayByCompany
@companyNo numeric(2,0),
@departmentNo numeric(10,0), 
@supDeptNo numeric(10,0)
as
Begin
SELECT HOLIDAY.HOLIDAY_DATE FROM HOLIDAY WHERE HOLIDAY.COMPANY_NO = @companyNo AND HOLIDAY.DEPARTMENT_NO = @departmentNo AND HOLIDAY.SUP_DEPARTMENT_NO = @supDeptNo
end